Order of operations in a formula
MyOffice Spreadsheet calculates formulas based on the following order of operations:
•Operations enclosed in parentheses are performed first:
•The order of operations depends on their priority.
•Operations in the nested parentheses are performed first.
|
If a formula contains the parentheses that are not essential in the calculation, they will be deleted automatically. For example, the formula =SUM(1+(2*5)+1) will be automatically transformed into =SUM(1+2*5+1). |
•Operations outside the parentheses are performed according to their precedence.
•Operations with the same precedence are performed from left to right, with the exception of the exponentiation (^), which is performed from right to left. Example: = 2^4^2 = 2^16 = 65,536.
If you combine several operators in a single formula, MyOffice Spreadsheet performs the operations in the order shown in the following table.
Priority |
Operator symbol |
Operator description |
|---|---|---|
1 |
: |
Range |
2 |
|
Space |
3 |
% |
Percentage |
4 |
+ -
|
Unary plus Unary minus Unary space |
5 |
^ |
Exponentiation |
6 |
* / |
Multiplication Division |
7 |
+ - |
Addition Subtraction |
8 |
& |
Combining two text strings into one |
9 |
= > < >= <= <> |
Comparison: Equal to Greater than Less than Greater than or equal to Less than or equal to Not equal to |
